﻿/*CREATE TABLE [dbo].[ProductoresRepresentantes] (
    [RepresentanteGuid]  UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [RepresentanteId]    INT              NOT NULL,
    [EstadoGuid]         UNIQUEIDENTIFIER NOT NULL,
    [EstadoId]           INT              NOT NULL,
    [DistritoGuid]       UNIQUEIDENTIFIER NULL,
    [DistritoId]         INT              NULL,
    [MunicipioGuid]      UNIQUEIDENTIFIER NOT NULL,
    [MunicipioId]        INT              NOT NULL,
    [ProductorGuid]      UNIQUEIDENTIFIER NOT NULL,
    [Nombre]             NVARCHAR (250)   NOT NULL,
    [Email]              NVARCHAR (250)   NULL,
    [Telefono]           NVARCHAR (50)    NULL,
    [Celular]            NVARCHAR (50)    NULL,
    [RFC]                NVARCHAR (50)    NULL,
    [CURP]               NVARCHAR (50)    NULL,
    [IFE]                NVARCHAR (MAX)   NULL,
    [Pasaporte]          NVARCHAR (MAX)   NULL,
    [Licencia]           NVARCHAR (MAX)   NULL,
    [OtraIdentificacion] NVARCHAR (MAX)   NULL,
    [Domicilio]          NTEXT            NULL,
    [Status]             BIT              NOT NULL
);*/

